/*************************************************************************
	> File Name: mysql_conn.cpp
	> Author: Wu Junqiang
	> Mail: 15769154659@163.com 
	> Created Time: 2018年01月03日 星期三 17时33分52秒
	> Note: Mysql 测试连接
 ************************************************************************/


#include <stdio.h>
#include <stdlib.h>
#include <mysql/mysql.h>


int main()
{
	MYSQL* conn;
	MYSQL_RES* res;
	MYSQL_ROW row;
	char server[] = "localhost";
	char user[] = "root";
	char password[] = "chunhengkeji";
	char database[] = "mysql";

	conn = mysql_init(NULL);

	if(!mysql_real_connect(conn,server,user,password,database,0,NULL,0))
	{
		fprintf(stderr,"%s\n",mysql_error(conn));
		exit(1);
	}

	if(mysql_query(conn,"show tables"))
	{
		fprintf(stderr,"%s\n", mysql_error(conn));
		exit(1);
	}
	res = mysql_use_result(conn);

	printf("Mysql tables in mysql database:]\n");

	while((row = mysql_fetch_row(res)) != NULL)
	{
		printf("%s\n",row[0]);
	}

	mysql_free_result(res);
	mysql_close(conn);

	printf("finish!\n");
	return 0;
}
